Instructions for Replication Packet
Paper: The value of insiders as mentors: Evidence from the effects of NSF rotators on early career scientists
By: Sebastian Hoenen (Rotterdam School of Management) and Christos Kolympiris (Warwick Business School)

The analysis was conducted with Stata version 15

The replication packet consists of the following files:

- Table 1 data.dta		: This is the Stata dataset to produce Table 1
- Table 1 do file.do		: This is the Stata code that uses the Table 1 data.dta to produce Table 1
- Table 2 data.dta		: This is the Stata dataset to produce Table 2
- Table 2 do file.do		: This is the Stata code that uses the Table 2 data.dta to produce Table 2
- Table 3 data.dta		: This is the Stata dataset to produce Table 3
- Table 3 do file.do		: This is the Stata code that uses the Table 3 data.dta to produce Table 3
- Table 4 data.dta		: This is the Stata dataset to produce Table 4
- Table 4 do file.do		: This is the Stata code that uses the Table 4 data.dta to produce Table 4
- Tables 5,6,7 data.dta		: This is the Stata dataset to produce Tables 5,6 and 7
- Tables 5,6,7 do file.do	: This is the Stata code that uses the Tables 5,6,7 data.dta to produce Tables 5,6 and 7
- Table 8 data.dta		: This is the Stata dataset to produce Table 8
- Table 8 do.do			: This is the Stata code that uses Table 8 data.dta to produce Table 8
	


The following is a dictionary for the main variables from all the ".dta" files:

personid				-	junior scientist ID      
rotatorid     				-	rotator ID
universityid  				-	university of junior scientist ID
departmentid				-	department of junior scientist ID
focal					-	cohort within treatment and control groups (focals defined in Table 1 data.dta)
group					-	Treatment or control group
yearjoinedtenure			-	Start year of Assistant Professor position
rotatorleave				-	Year the rotator left for the NSF
rotatorreturn				-	Year the rotator returned from the NSF
withintreatmentgroupjoinedwhenor	-	1 if within treatment group, personID joined when or shortly after the rotator returned from the NSF
withintreatmentgroupjoinedwhenth	-	1 if within treatment group, personID joined when the rotator was at the NSF
withintreatmentgroupjoinedwithin  	-	1 if within treatment group, personID joined within two to five years before the rotator had left for the NSF
previous				-	Previous NSF funding at the start of the faculty post ($M)
yearly					-	Yearly NSF funding from the start of the faculty post until the rotator's return from the NSF ($M)
total					-	Total NSF funding in the 5 years ex-post rotator return ($M)
male					-	Takes the value of 1 if personid is male, 0 otherwise
post					-	Years as a Post-Doc
hindex					-	H-index at the time of the first faculty post
nonnsf					-	Yearly non-NSF funding until first faculty post ($M)
years					-	Years between PhD graduation and first faculty post
first					-	Takes the value of 1 if personID had a first author publication before PhD graduation, 0 otherwise
facultysumnsfbeforejoin			-	Total yearly department NSF funding the five years preceding the rotator’s return from the NSF (Table 2)
facultysumnsfbeforejoinperyear		-	Average yearly department NSF funding the five years preceding the rotator’s return from the NSF (Table 2)
facultysumnsfbeforejoinperyearpe	-	Average yearly department NSF funding per faculty the five years preceding the rotator’s return from the NSF (Table 2)
quartile				-	Department Shanghai ranking quartile of the focal department the year the rotator’ return (Table 3)
aau					-	1 if the focal university is part of Association of American Universities, 0 otherwise (Table 3)
years					-	Years in rotation (Table 4)
careerageatstartofrotation		-	Career age at start of rotation (Table 4)
pub5yearbefore				-	Publications (5 years ex-ante) (Table 4)
cites5yearbefore			-	Total citations from papers publsuhed 5 years before rotation (Table 4)
citesperpaper5yearbefore		-	Citations per paper (5 years ex-ante) (Table 4)
pisum5yearsbefore			-	NSF funding as PI (5 years ex-ante) (Table 4)
tr_minus5				-	RotatorDepartment t-5 (Table 5)
tr_minus4				-	RotatorDepartment t-4 (Table 5)
tr_minus3				-	RotatorDepartment t-3 (Table 5)
tr_minus2				-	RotatorDepartment t-2 (Table 5)
tr_minus1				-	RotatorDepartment t-1 (Table 5)
Tr0					-	Treatment 0 (Table 5)
Tr1					-	Treatment 1 (Table 5)
Tr2					-	Treatment 2 (Table 5)
Tr3					-	Treatment 3 (Table 5)
Tr4					-	Treatment 4 (Table 5)
Tr5					-	Treatment 5 (Table 5) 
YearsPostDoc				-	PostDoc (Table 5)
AssistantProfessor			-	Assistant Professor (Table 5)
AssociateProfessor			-	Associate Professor (Table 5)
Male					-	Male (Table 5)
hindexlag				-	H-index (Table 5)
ExternalFunding_mil			-	External Funding ($M) (Table 5)
NSFFundingPrev5Years_mil		-	Previous NSF ($M) (Table 5)
CurrentUniversityQuartile		-	Ranking (Table 5)
FacultySumNSFBefore_millions		-	Faculty NSF ($M) (Table 5)
NSFFunding_mil				-	Dependent variable - Yearly NSF funding (Table 5)
y50k					-	Dependent variable - 1 if grant above 50K, 0 otherwise (Table 6)
y250k					-	Dependent variable - 1 if grant above 250K, 0 otherwise (Table 6)
y500k					-	Dependent variable - 1 if grant above 500K, 0 otherwise (Table 6)
y1000k					-	Dependent variable - 1 if grant above 1000K, 0 otherwise (Table 6)
AfterRotator				-	Takes the value of 1 if the focal scientist joined the department after the rotator returned from the NSF, 0 otherwise (Table 7)
joined1yearbeforetherotatorretur	-	Joined 1 year before the rotator returned = group 1 (Table 8)
joinedthesameyeartherotatorretur	-	Joined the same year the rotator returned = group2 (Table 8)
joined1yearaftertherotatorreturn	-	Joined 1 year after  the rotator returned = group 3 (Table 8)
joined2yearsaftertherotatorretur	-	Joined 2 years after  the rotator returned = group 4 (Table 8)

